SELECTOBJECT_NAME(a.parent_obj)AS[表名], a.nameAS[触发器名称], (CASEWHENb.is_disabled=0THEN'启用' ELSE'禁用' END)AS[状态], b.create_dateAS[创建日期], b.modify_dateAS[修改日期], c.textAS[触发器语句] FROMsysobjectsa INNERJOINsys.triggersbONb.object_id=a.id INNERJOINsyscommentscONc.id=a.id WHEREa.xtype='tr' ORDERBY[表名]